Skip to main content

What is DevolutionSync?

DevolutionSync is a PHP-based enterprise management system designed to streamline the tracking, approval, and resolution of product returns, shortages, and surpluses in distribution operations. Built with modern PHP 8.2 and containerized deployment, it provides a complete workflow for managing product deviations across your organization.

Key Problems It Solves

Manual Tracking

Eliminates spreadsheets and paper-based tracking of product returns with a centralized digital system

Approval Bottlenecks

Streamlines the approval workflow with role-based access and real-time notifications

Data Visibility

Provides dashboard insights into return patterns, approval rates, and deviation trends

Evidence Management

Centralizes photo evidence and documentation for all product deviation cases

Key Features

Role-Based Access Control

Three distinct user roles with specific permissions:
  • Admin (Grado 1): Full system access, approve/reject returns, user management, dashboard analytics
  • Auxiliary (Grado 2): Create and submit product return requests with evidence upload
  • Consultation (Grado 3): Read-only access to view historical records and reports

Product Return Workflow

1

Registration

Auxiliary users register product deviations with customer details, product codes, quantities, and photographic evidence
2

Review

Admin reviews pending requests with all supporting documentation and evidence
3

Decision

Admin approves or rejects with authorization codes and observations
4

Notification

System notifies the originating user of the decision and next steps

Deviation Types Supported

  • Devolución (Return): Products returned by customers due to defects or errors
  • Faltante (Shortage): Missing products or quantity discrepancies
  • Sobrante (Surplus): Excess products or overage situations

Technical Capabilities

  • MVC Architecture: Clean separation of concerns with Controllers, Models, and Views
  • PDO Database Layer: Secure parameterized queries preventing SQL injection
  • Session Management: 3-minute inactivity timeout with automatic logout
  • File Upload Handling: Secure evidence upload with validation (JPG, PNG, GIF up to 5MB)
  • Dashboard Analytics: Real-time statistics on returns by status, motivo, weight, and count

System Requirements

DevolutionSync is designed for containerized deployment with minimal infrastructure requirements.

Server Requirements

  • PHP: 8.2 or higher
  • Web Server: Apache 2.4+
  • Database: MySQL 5.7+ or MariaDB 10.3+
  • Extensions: PDO, pdo_mysql, mysqli

Deployment Options

Browser Compatibility

  • Chrome 90+
  • Firefox 88+
  • Safari 14+
  • Edge 90+

Architecture Overview

DevolutionSync/
├── index.php              # Front controller with routing
├── Config/
│   └── Conexion.php       # PDO database connection
├── Controllers/           # Business logic layer
│   ├── AuthController.php
│   ├── HomeController.php
│   ├── AdminController.php
│   └── PanelController.php
├── Models/                # Data access layer
│   ├── AuthModel.php
│   ├── DevolucionModel.php
│   └── ProductoModel.php
├── Views/                 # Presentation layer
│   ├── auth/
│   ├── home/
│   └── admin/
└── uploads/               # User-uploaded evidence files

Next Steps

Quick Start

Get DevolutionSync running in 5 minutes with Docker Compose

Installation Guide

Detailed setup instructions for production deployment
The system uses session-based authentication with a 3-minute inactivity timeout. Ensure your deployment environment supports PHP sessions.